package com.k.demo.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.k.demo.entity.Balance;

@Mapper
public interface BalanceMapper {
	
	@Select("select * from balance where balance_date>=to_date(#{start_date},'yyyy-mm-dd hh24:mi:ss') and balance_date<=to_date(#{end_date},'yyyy-mm-dd hh24:mi:ss')+1")
	public List<Balance> selectFromStartToEnd(String start_date,String end_date);
	
	@Select("select * from balance where trunc(balance_date)=trunc(sysdate)")
	Balance seleteTodaysBalance();
	
	int update(Balance balance);
	
	int insert(Balance balance);
}
